Syllabus Information

5.1. Methodological overview

The learning process of this course is based on:

• The presentation of contents by the professors, and the resolution of exercises in class.
• The personal study by the students and their participation in class in solving exercises.
• The completion of practical assignments by the students, oriented by the professors, who will develop the theoretical knowledge acquired.
• The development and defense of practical assignments in groups, oriented by the professors.
• The personalized attention to the student, through tutoring, with the goal of revising and discussing materials and topics presented in class.

It must be taken into account that, although the course has a practical orientation, acquiring the needed theoretical knowledge is also required. Therefore, the learning process emphasizes both the theoretical concepts and the individualized study as well as the development of the practical work.

5.2. Learning tasks

The program helps achieving the expected learning goals by including the following activities...

• In the classes, the program of the course will be developed.
• In problem-solving sessions, problems and exercises will be solved, and activities related to the reading and discussion of relevant texts may be performed.
• Laboratory sessions will be developed in a computer lab. In those sessions, the students will perform practical assignments related with the course.

5.3. Syllabus

1. Introduction to data warehouses:

• Basic concepts:
  
  • Analysis of user requirements.
  • Life cycle.
  • The problem of integration of data sources.
  • OLTP transactions vs. OLAP.

• Architecture of data warehouses:
  
  • Conceptual, logical and physical design.
  • ETL process.

• Commercial systems.

2. Introduction to data mining:

• Knowledge and data discovery.
• Web mining.
• Tools for data mining.
• Application fields, such as:
  
  • Decision making (Banks-financing-insurance, marketing, health/demographic policies, etc.).
  • Industrial processes.
  • Reverse Engineering.

5.4. Course planning and calendar

The calendar of classes, lab sessions and exams, as well as the dates of delivery of evaluation assignments, will be announced in advance, according to the sessions and dates established by the School.

5.5. Bibliography and recommended resources

[BB: Bibliografía básica / BC: Bibliografía complementaria]

Zaragoza:

• [BB] Adamson, Christopher. Star schema : the complete reference / Christopher Adamson . New York : McGraw-Hill, 2010
• [BB] Jensen, Christian S. Multidimensional databases and data warehousing / Christian S. Jensen, Torben Bach Pedersen, Christian Thomsen . [San Rafael (California)] : Morgan & Claypool Publishers, cop. 2010
• [BB] Kimball, Ralph. The data warehouse toolkit : the definitive guide to dimensional modeling / Ralph Kimball, Margy Ross . 3rd ed. Indianapolis : John Wiley & sons, cop. 2013
• [BC] Malinowski, Elzbieta. Advanced data warehouse design : from conventional to spatial and temporal applications / Elzbieta Malinowski, Esteban Zimányi . [1st ed.], 2nd corr. print. Berlin : Springer, cop. 2009
• [BC] liu, Bing. Web Data Mining: Exploring Hyperlinks, Contents, and Usage Data / Bing Liu Springer, 2011.
• [BC] Sumathi, S.. Introduction to Data Mining and its Applications / S. Sumathi, S. N. Sivanandam Springer, 2006.

Listado de URL

• Transparencias, bibliografía comentada, enunciados de problemas, casos de estudio y guiones de prácticas que los profesores de la asignatura pondrán a disposición del alumnado mediante la plataforma Moodle 2 del Anillo Digital Docente. [http://add.unizar.es]

Teruel:

• [BB] Jensen, Christian S.. Multidimensional databases and data warehousing / Christian S. Jensen, Torben Bach Pedersen, Christian Thomsen . [San Rafael (California)] : Morgan & Claypool Publishers, cop. 2010
• [BB] Malibowski, E. Advanced Data Warehouse Design [Recurso electrónico] :]From Conventional to Spatial and Temporal Applications / Elzbieta Malinowski, Esteban Zimányi. Berlin, Heidelberg : Springer-Verlag Berlin Heidelberg, 2008
• [BC] Liu, B. Web data mining :exploring hyperlinks, contents, and usage data / Bing Liu. Heidelberg ; New York : Springer, cop. 2011
• [BC] Sumathi, S. Introduction to Data Mining and its Applications [Recurso electrónico] / S. Sumathi, S. N. Sivanandam Berlin, Heidelberg : Springer-Verlag Berlin Heidelberg, 2006
• [BC] The data warehouse lifecycle toolkit [Recurso electrónico] / Ralph Kimball ... [et al.].. ndianapolis, Ind. : Wiley Pub., 2008